Due to the limitations of spreadsheet packages like Excel, in rare instances generated Journey Time files may exceed the possibilities of the data that can be contained within a single xls file (or when Excel attempts to open a very large csv file). For instance, if a file contains more than 256 columns or more than 65,536 rows, it cannot be opened within Excel.

Depending on the amount of analyses (columns) being run in a simulation and the number of Entities (rows) involved, a Journey Time file may need to be split into two or more files. LEGION Simulators handles this in the following ways.

Splitting csv files

The naming convention for a generated csv file is:

where JT indicates that it is a Journey Time file, HH-MM-SS are Hours, Minutes and Seconds and DD-MM-YY are Day, Month and Year. The element _x represents a split when there are too many columns, _y represents a split when there are too many rows.

For a file named JT (Stairs.ana) 14-25-41 04-11-04_x_y.csv, the following files would be generated, depending on the number of columns and rows it contains:

Large xls files

When an xls JT file exceeds the permissible amount of rows and columns, extra tabbed worksheets are automatically generated. These tabs are named Detail 1 Part 1, Detail 2 Part 1, Detail 1 Part 2, Detail 2 Part 2 and so on, in a similar manner to the csv file names listed above.